package Modele;

import java.sql.*;

/**
 *
 * @author sio
 */
public class Connect { //singleton
    
    private static Connection con = null;
    private static Connection open(){
        
        try {
            Class.forName("org.postgresql.Driver");
        } catch(ClassNotFoundException e) {
            System.out.println("Pilote mal installé ..." + e);
        }
        try {
            con = DriverManager.getConnection("jdbc:postgresql://lucie/medecin", "qfougereau", "linux");
        } catch(SQLException e) {
            System.out.println("Erreur SQL" + e);
        }
        return con;
    }  
    
    public static Connection get(){
        if (con == null){
            con = Connect.open();
        }
        return con;
    }
    public static void close() {
        try {
            con.close();
        } catch(SQLException e) {
            System.out.println("Erreur SQL" + e);
        }
    }
}
